programming - sqlite - operations | What links here? |
CREATE INDEX idx1 ON fruitsforsale(fruit);Create index on two columns of the fruitsforsale table:
CREATE INDEX Idx3 ON FruitsForSale(fruit, state);Select with output ordered by specific column:
SELECT * FROM fruitsforsale ORDER BY fruit;Select of specific rows with output ordered by specific column:
SELECT price FROM fruitforsale WHERE fruit='Orange' ORDER BY state
filename: | programming - sqlite - operations |
filename: | programming%20%2D%20sqlite%20%2D%20operations |
last edit: | April 18 2012 20:27:38 (4400 days ago) |
ct | = 1714980117.000000 = May 06 2024 03:21:57 |
ft | = 1334795258.000000 = April 18 2012 20:27:38 |
dt | = 380184859.000000 |